SRS Web Service Reports
Segpay recommends that reporting services are used in conjunction with the postback notification system.
There are several benefits:
-
Pulling data from reporting services provides a backup in case postbacks don’t go through.
-
You can pull data from reporting services on a set schedule, for use as a reconciliation tool. We recommend you pull transaction data from the previous day’s transactions only. As a reminder, the Segpay system operates on GMT.
For more information about Segpay's reporting services, please see:
Data Availability Chart
| Data Element | Definition | SRS | Postbacks |
|---|---|---|---|
| URL | Website | X |
X |
| Transaction ID | n/a | X | X |
| Related Transaction ID | Original transaction ID associated with a chargeback, refund, or void | X | X |
| Transaction Time | Time Stamp of transaction | X | X |
| Type | Sale, voice, refund, chargeback, one-click | X | X |
| Source | Sign-up, conversion, rebill, system | X | X |
| Auth | Yes or No | X | X |
| Transaction Amount | n/a | X | X |
| Currency | n/a | X | X |
| AuthCode | Bank response to an authorization or decline | X | |
| Purchase ID | n/a | X | X |
| Purch Type | Identifies if one time, recurring, digital purchase, instant conversion. | X | |
| Customer Name | n/a | X | X |
| Customer Email | n/a | X |
X |
| Customer Address | n/a | X | X |
| Customer City | n/a | X | X |
| Customer State | n/a | X | X |
| Customer Zip | n/a | X | X |
| Customer Country | n/a | X | X |
| Customer Phone | n/a | X | X |
| Customer IP | n/a | X | X |
| IP Country | n/a | X | |
| Username | n/a | X | X |
| Purchase Status | Status of the subscription (active, canceled, expired) | X | |
| Initial Amount | Sign-up Amount | X | X |
| Recurring Amount | n/a | X | X |
| Recurring Period | n/a | X | X |
| Next Date | Next rebill date | X | |
| Cancel Date | Date consumer canceled | X | |
| Expired Date | Date membership expires | X | |
| Retries | n/a | X | |
| Last Result | Identifies the approval or decline result of most recent transaction. | X | |
| Merchant Partner ID | The affiliate ID passed in by the merchant. | X | X |
| eticketID | This is the package ID and bill config ID to identify the price point and website the purchase was made to. | X | X |
| REF Variables | Up to 10 variables that you pass through (REF1 - REF10) | X | X |
| UserData | Grouping of all user-defined variables passed through by the merchant. In the SRS reports it also includes paypage languages and browser type/version. | X | X |
| Bin / First 6 | First 6 credit card digits | X | X |
| Last 4 | Last 4 credit card digits | X | X |
| Bin Country | Country where BIN is from | X | |
| Refund entered by | n/a | X | |
| Refund Reason Code | n/a | X | |
| Refund Comment | n/a | X |